Reporting from the repository

The repository can be a data source for your favorite reporting applications. You can configure reports against the repository using any application that supports SQL Server or Oracle as a data source, for example, Microsoft SQL Server Reporting Services or SAP Crystal Reports.

The repository database includes almost 50 interrelated tables. To simplify reporting, the repository predefines views upon which you can base your reports:

• DocumentView – Includes all properties for all document revisions. Filter on the IsLatestRevision column to exclude prior revisions.
• ObjectTagView – Includes all properties for all asset object revisions. Filter on the IsLatestRevision column to exclude prior revisions.

We recommend that you create reports on these views, not on the source tables. If you have special requirements that cannot be easily met using these views, contact your BlueCielo Solution Partner or BlueCielo ECM Solutions Professional Services for more specific views.